sql / as sysdba

show pdbs

SELECT NAME,OPEN_MODE,CON_ID FROM V$PDBS;

CREATE PLUGGABLE DATABASE PDB2 ADMIN USER PDB_ADMIN IDENTIFIED BY Password_1 CREATE_FILE_DEST='/u01/app/oracle/oradata';

show pdbs

ALTER PLUGGABLE DATABASE PDB2 OPEN;

show pdbs

sql / as sysdba

CREATE USER C##LABCOMMONUSER IDENTIFIED BY Password_1 CONTAINER=ALL;

GRANT CREATE SESSION TO C##LABCOMMONUSER CONTAINER=ALL;

SHOW CON_NAME

SELECT USER FROM DUAL;

sql C##LABCOMMONUSER@//localhost:1521/pdb2

show con_name

SELECT USER FROM DUAL;

sql / as sysdba

show pdbs

SHOW CON_NAME

ALTER SESSION SET CONTAINER=PDB1;

show con_name

ALTER SESSION SET CONTAINER=PDB2;

SHOW CON_NAME


mkdir -p /u01/app/oracle/oradata/DB01/pdb3

chmod 775 /u01/app/oracle/oradata/DB01/pdb3

sql / as sysdba

CREATE PLUGGABLE DATABASE PDB3 FROM PDB1 FILE_NAME_CONVERT=('/u01/app/oracle/oradata/DB01/pdb1', '/u01/app/oracle/oradata/DB01/pdb3');

show pdbs

ALTER PLUGGABLE DATABASE PDB3 OPEN;

ALTER PLUGGABLE DATABASE ALL SAVE STATE;

SHOW PDBS

ALTER PLUGGABLE DATABASE PDB3 CLOSE;

SHOW PDBS

DROP PLUGGABLE DATABASE PDB3 INCLUDING DATAFILES;

show pdbs



